SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.DnnProduct_GetServerConfiguration 
AS
	SELECT 
		CASE WHEN COUNT(ServerName) > 1 THEN 1 ELSE 0 END As IsWebFarm,
		CASE WHEN COUNT(DISTINCT ServerName+IISAppName) > COUNT(DISTINCT ServerName) THEN 1 ELSE 0 END As UseAppName
	 FROM dbo.DnnProduct_WebServers
	WHERE Enabled = 1
GO
